create external table jms_dm.dm_lmdm_four_segment_push_detail_dt 
(
waybill_no string COMMENT '' ,
sign_network_code     string COMMENT '签收网点' ,
sign_network_name     string COMMENT '签收网点' ,
sign_agent_code       string COMMENT ''代理区编码',' ,
sign_agent_name       string COMMENT ''代理区名称,',' ,
sign_provider_id       string COMMENT ''省份ID',' ,
sign_provider_desc     string COMMENT ''省份',' ,
sign_city_id           string COMMENT ''城市ID',' ,
sign_city_desc         string COMMENT ''城市',' ,
terminal_dispatch_code  string COMMENT ''面单三短码',' ,
is_deliver           string COMMENT '是否出仓' ,
deliver_third_code  string COMMENT '出仓业务员三段码' ,
third_code             string COMMENT '驿站补推三段码' ,
courier_station_code    string COMMENT '驿站码编码' ,
station_unique_number     bigint COMMENT '驿站码唯一标识' ,
is_txd   string COMMENT '是否推送桃花岛' ,
is_qxt   string COMMENT '是否推送七星潭' ,
is_jms  string COMMENT '是否推JMS' ,
input_type   string COMMENT ''补推来源'' ,
input_type_name   string COMMENT ''补推来源'' ,
date_time   timestamp COMMENT '查询日期' ,
 string COMMENT '' )
comment 'insert overwrite table jms_dm.dm_lmdm_four_segment_push_detail_dt partition (dt)'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_lmdm_four_segment_push_detail_dt'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');
